package com.showde.shoppingmall.db.constant;

public class ProductInBillConstant extends ConstantBase {

	public static final String TABLENAME = "t_product_in_bill";

	public static final String BILLID = "BILLID"; // 订单ID
	public static final String PRODUCTID = "PRODUCTID";// 商品ID
	public static final String PRODUCTNAME = "PRODUCTNAME";// 商品名称
	public static final String PRODUCTICONURL = "PRODUCTICONURL";// 商品图片地址
	public static final String PRODUCTORIGNALPRICE = "PRODUCTORIGNALPRICE";// 商品原价
	public static final String PRODUCTPRICECUT = "PRODUCTPRICECUT"; // 商品减免价
	public static final String PRODUCTCOUNT = "PRODUCTCOUNT";// 商品数量
	public static final String POINT = "POINT"; // 积分

	public static final int COLUMN_BILLID = 1; // 订单ID
	public static final int COLUMN_PRODUCTID = 2;// 商品ID
	public static final int COLUMN_PRODUCTNAME = 3;// 商品名称
	public static final int COLUMN_PRODUCTICONURL = 4;// 商品图片地址
	public static final int COLUMN_PRODUCTORIGNALPRICE = 5;// 商品原价
	public static final int COLUMN_PRODUCTPRICECUT = 6;// 商品减免价
	public static final int COLUMN_PRODUCTCOUNT = 5;// 商品数量
	public static final int COLUMN_POINT = 6;// 积分

	public static final String[] dbColumns = new String[] { BILLID, PRODUCTID,
			PRODUCTNAME, PRODUCTICONURL, PRODUCTORIGNALPRICE, PRODUCTPRICECUT,
			PRODUCTCOUNT, POINT };

	public static final String SQL_CREAT = "create table 't_product_in_bill'("
			+ "'_id' int primary key, " + "'BILLID' int not null, "
			+ "'PRODUCTID' varchar(50), " + "'PRODUCTNAME' varchar(40), "
			+ "'PRODUCTICONURL' varchar(200), "
			+ "'PRODUCTORIGNALPRICE' float, " + "'PRODUCTPRICECUT' float, "
			+ "'PRODUCTCOUNT' int, " + "'POINT' int)";

}
